import os

import xlrd

file_path=os.path.dirname(os.path.abspath(__file__))
print(file_path)
data_path=os.path.join(file_path, 'data2.xlsx')
print(data_path)
book=xlrd.open_workbook(data_path)
table1=book.sheets()[0]
lis=table1.row(0)
print(table1.nrows)
print(lis)
res_data=[]
print(table1.cell_value(1,4))
title=table1.row_values(0)
print(title)
print(type(title))
for row in range(1,table1.nrows):
    data=table1.row_values(row)
    print(type(data))
    print(dict(zip(title,data)))
    res_data.append(dict(zip(title,data)))

# ssre='djlfsjdlfjdlfjdsljfdlsjf'
# res=ssre.split(s)

params = {
 "auditStatus": 0,
 "pageNum": 0,
 "pageSize": 0
}
# if len(str(params).split()) == 0:
#     pass
# elif len(str(params)) >= 0:
#     params = params

sss=len(str(params))
print(sss)
